package com.smartwebx.ha.dal.realtime.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.smartwebx.ha.dal.config.OracleConfigInfo;
import com.smartwebx.ha.dal.usebean.HjAndKjBean;

/**
 * 洪警、枯警
 * 
 * @author yyf
 * 
 */
public interface HjAndKjMapper {
	String ST_HJ_B = OracleConfigInfo.REALTIME_NAME_HJANDKJ + ".ST_HJ_B";
	String ST_KJ_B = OracleConfigInfo.REALTIME_NAME_HJANDKJ + ".ST_KJ_B";
	
	/**
	 * 单站洪警数据
	 * 
	 * @param stcd
	 * @return
	 */
	@Select("SELECT * FROM "
			+ ST_HJ_B
			+ " WHERE STCD=#{stcd}")
	public List<HjAndKjBean> selectHjByStcd(@Param("stcd") String stcd);
	
	/**
	 * 单站枯警数据
	 * 
	 * @param stcd
	 * @return
	 */
	@Select("SELECT * FROM "
			+ ST_KJ_B
			+ " WHERE STCD=#{stcd}")
	public List<HjAndKjBean> selectKjByStcd(@Param("stcd") String stcd);
}
